Open topic with navigation

Database reference guide

 HOME

NSQL Intrinsic Functions

Certain functions can be applied to certain columns before the query is performed. The WHERE clause takes the form:

[NOT] Function(<column>) Operator “Value”

[NOT] Function(<column>) [X]BETWEEN “Lower Value” AND “Upper Value”

[NOT] Function(<column>) IN ( <comma separated list of values> )


Functions that can be applied are as follows:

  • ABS - <column>
  • AGE - <column>,"DATE"
  • ALLMONTHS - <column>
  • ALLQUARTERS - <column>
  • BIGINT - <column>
  • CEIL - <column>
  • CHR - <column>
  • CODE - <column>
  • CUMUL - <column>
  • DAY - <column>
  • DAYSTO - <column>,"DATE"
  • DISTANCE - <column>,<value>
  • EXP - <column>
  • FLOOR - <column>
  • HOUR - <column>
  • INT - <column>
  • LCASE - <column>
  • LEFT - <column>,<number>
  • LEN - <column>
  • LOG - <column>
  • LOG10 - <column>
  • MINUTE - <column>
  • MONTH - <column>
  • NORMALISE - <column>
  • PAREA - <column>
  • PDIST - <column>
  • POWER - <column>,<number>
  • PROPER - <column>
  • QUARTER - <column>
  • RAND - <number>
  • RIGHT - <column>,<number>
  • SECOND - <column>
  • SGN - <column>
  • SORTFORMAT - <column>
  • SOUNDS - <column>
  • SQRT - <column>
  • STRING - <column>
  • STRIP - <column>
  • UCASE - <column>
  • WEEKDAY - <column>
  • YEAR - <column>
  Online & Instructor-Led Courses | Training Videos | Webinar Recordings
© Alterian. All Rights Reserved. | Privacy Policy | Legal Notice